$userdata = $db_zugriff->query_first("SELECT bb".$n."_user_table.*, bb".$n."_groups.* FROM bb".$n."_user_table LEFT JOIN bb".$n."_groups ON (bb".$n."_groups.id=bb".$n."_user_table.groupid) WHERE userid='$user_id'");
$result = $db_zugriff->query_first("SELECT userid FROM bb".$n."_user_table WHERE username='$usernick'");
return $result[userid];
}
function getUsername($userid) {
global $n,$db_zugriff;
$result = $db_zugriff->query_first("SELECT username FROM bb".$n."_user_table WHERE userid='$userid'");
return $result[username];
}
function getUserEmail($userid) {
global $n,$db_zugriff;
$result = $db_zugriff->query_first("SELECT useremail FROM bb".$n."_user_table WHERE userid='$userid'");
return $result[useremail];
}
function check_userdata($userid,$password) {
global $n, $db_zugriff;
$result = $db_zugriff->query_first("SELECT COUNT(userid) FROM bb".$n."_user_table WHERE userid='$userid' AND userpassword = '$password' AND activation = 1");
return $result[0];
}
function checkUser($username,$password) {
global $n,$db_zugriff;
$result = $db_zugriff->query_first("SELECT userpassword FROM bb".$n."_user_table WHERE username='$username' && activation='1'");
$thread = $db_zugriff->query_first("SELECT boardparentid, replies FROM bb".$n."_threads WHERE threadid='$threadid' ORDER by timelastreply DESC");
$posts = $thread[replies]+1;
$result = $db_zugriff->query("SELECT posttime FROM bb".$n."_posts WHERE threadparentid='$threadid' ORDER by posttime ".ifelse($postorder,"DESC","ASC"));
$user = $db_zugriff->query_first("SELECT COUNT(userid) as anzahl FROM bb".$n."_user_table WHERE userid='$userid' AND invisible='0'");
if($user[anzahl]) $anzahl = $db_zugriff->query_first("SELECT COUNT(zeit)as anzahl FROM bb".$n."_useronline WHERE userid='$userid'");
return $anzahl[anzahl];
}
function delPost($postid,$threadid,$boardid) {
global $n,$db_zugriff;
$threadinfo = $db_zugriff->query_first("SELECT replies FROM bb".$n."_threads WHERE threadid = '$threadid'");
if(!$threadinfo[replies]) {
$author = $db_zugriff->query_first("SELECT userid FROM bb".$n."_posts WHERE postid = '$postid'");
delUserposts($author[0]);
$db_zugriff->query("DELETE FROM bb".$n."_threads WHERE threadid='$threadid'");
$db_zugriff->query("DELETE FROM bb".$n."_posts WHERE postid='$postid'");
$pinfo = $db_zugriff->query_first("SELECT postid, posttime, userid FROM bb".$n."_posts WHERE boardparentid = '$boardid' ORDER BY posttime DESC LIMIT 1");
$db_zugriff->query("UPDATE bb".$n."_boards SET threads=threads-1, posts=posts-1, lastposttime = '$pinfo[posttime]', lastpostid = '$pinfo[postid]' WHERE boardid = '$boardid'");
$db_zugriff->query("DELETE FROM bb".$n."_notify WHERE threadid='$threadid'");
$db_zugriff->query("DELETE FROM bb".$n."_poll WHERE threadid='$threadid'");
$db_zugriff->query("DELETE FROM bb".$n."_vote WHERE threadid='$threadid'");
$db_zugriff->query("DELETE FROM bb".$n."_object2user WHERE objectid='$threadid' AND favthreads = 1");
return 2;
}
else {
$author = $db_zugriff->query_first("SELECT userid FROM bb".$n."_posts WHERE postid = '$postid'");
delUserposts($author[0]);
$db_zugriff->query("DELETE FROM bb".$n."_posts WHERE postid='$postid'");
$tinfo=$db_zugriff->query_first("SELECT userid, posttime FROM bb".$n."_posts WHERE threadparentid='$threadid' ORDER BY posttime DESC");
$db_zugriff->query("UPDATE bb".$n."_threads SET replies=replies-1, timelastreply='$tinfo[posttime]', lastposterid='$tinfo[userid]' WHERE threadid = '$threadid'");
$pinfo = $db_zugriff->query_first("SELECT postid, posttime FROM bb".$n."_posts WHERE boardparentid = '$boardid' ORDER BY posttime DESC LIMIT 1");
$db_zugriff->query("UPDATE bb".$n."_boards SET posts=posts-1, lastposttime = '$pinfo[posttime]', lastpostid = '$pinfo[postid]' WHERE boardid = '$boardid'");
return 1;
}
}
function delUserposts($userid) {
global $n,$db_zugriff;
$db_zugriff->query("UPDATE bb".$n."_user_table SET userposts=userposts-1 WHERE userid='$userid'");
}
function formatdate($time,$format,$replacetoday=0) {
global $db_zugriff, $n, $timetype, $timeoffset, $today;
else $db_zugriff->query("INSERT INTO bb".$n."_object2user (userid,objectid,$field) VALUES ('$userid','$id','1')");
}
return $output;
}
function rowcolor($zeile) {
if (($zeile/2) != floor($zeile/2)) $color="tableb";
else $color="tablec";
return $color;
}
function getBoardparent($threadid) {
global $n,$db_zugriff;
$result = $db_zugriff->query_first("SELECT boardparentid FROM bb".$n."_threads WHERE threadid='$threadid'");
return $result[boardparentid];
}
function unsubscripe($id,$userid,$b_or_t) {
global $n,$db_zugriff;
$field = "fav".$b_or_t;
$db_zugriff->query("DELETE FROM bb".$n."_object2user WHERE userid = '$userid' AND objectid = '$id' AND $field = 1");
}
function getUserStars($posts,$groupid) {
global $n,$db_zugriff;
$result = $db_zugriff->query_first("SELECT id, rank, grafik, mal FROM bb".$n."_ranks WHERE groupid = $groupid AND posts<='$posts' ORDER by posts DESC");
global $master_board_name, $php_path, $master_email, $db_zugriff, $n;
$mod = $db_zugriff->query_first("SELECT bb".$n."_object2board.objectid, useremail FROM bb".$n."_object2board LEFT JOIN bb".$n."_user_table ON (bb".$n."_object2board.objectid=bb".$n."_user_table.userid) WHERE boardid='$boardid' AND mod=1");
if(!$mod[useremail]) $mod = $db_zugriff->query_first("SELECT bb".$n."_object2board.objectid, useremail FROM bb".$n."_object2board LEFT JOIN bb".$n."_user_table ON (bb".$n."_object2board.objectid=bb".$n."_user_table.userid) WHERE mod=1");
if(!$mod[useremail]) $mod = $db_zugriff->query_first("SELECT bb".$n."_groups.id, useremail FROM bb".$n."_groups LEFT JOIN bb".$n."_user_table ON (bb".$n."_groups.id=bb".$n."_user_table.groupid) WHERE ismod=1 OR issupermod=1 ORDER BY ismod DESC");
$post = $db_zugriff->query_first("SELECT userid, message FROM bb".$n."_posts WHERE postid='$postid'");